let userSQL = {
  userLogin: "select * from user where userName=? and userPass=?", // 查询并升序排序
  addUser: "insert into user(userName,userPass,userAge,userSex,userEmail,createTime,updateTime) values(?,?,?,?,?,?,?)",
  selsctUser:"select * from user",
  addRoom:"insert into room(roomName,createTime,updateTime,created) values(?,?,?,?)",
  selectRoom:"select * from room where created=?",
  selUserInfo:"select * from user where id=?",
  updateUser:"update user set userName=?,userAge=?,userSex=?,userEmail=?,updateTime=? where id=?",
  updateUserPass:"update user set userPass=? where id=?",
  addUserRoom:"insert into user_add_room(roomId,userId) values(?,?)",
  selectRoom2:"select * from room where roomId=? and created=?",
  outUserInRoom:"delete from user_add_room where roomId=? and userId=?",
  delRoom:"delete from room where roomId=? and created=?",
  outUserInRoom2:"delete from user_add_room where roomId=?",
  groupChats:"select u.* from user as u join user_add_room as uar on uar.userId=u.id where uar.roomId=?",
  selectRoom3:`select * from room where roomName like %?%`,
  selsctUser2:`select id,userName,userSex,userAge from user where userName like concat('%',?,'%')`
};
export default userSQL;
